discuz 如何添加数据DB::insert和更新数据DB::update 查询DB::qu
$list[] = $value;
echo '<table width="100%" border=1>';
echo "<td><a href='admin.php?action=goldhall&id={$v['id']}&type=gold&op=cancle'>取消金牌展厅</a></td>";
$arr=array();
$arr['display_type'] = $display_type;
$perpage = 25;
//删除
3.查询,返回结果集
}else{
if($op == 'add'){
echo $multipage;
if($gid){ //还要删除文件
if($type == 'gold'){
echo "<td>{$v['hallname']}</td>";
$username=empty($_POST['username']) ? "" : $_POST['username'];
}else{
$start = ($page-1)*$perpage;
if($v['isindex'] == 1){
$data = DB::fetch($query);
}elseif($op = 'cancle'){
$mpurl = ADMINSCRIPT.'?action=goldhall';
if($query){
1.添加数据DB::insert
$count = DB::result(DB::query("select uid from pre_common_member where uid= $uid"), 0);
mkdir("data/video/{$uid}/cover", 0700);
}
}
if(!empty($_POST['uid']) && !empty($_POST['display_type']) && !empty($_POST['display_type'] ))
{
echo '没有此展厅';
$videoname=empty($_POST['videoname']) ? "" : $_POST['videoname'];
}elseif($op = 'cancle'){
$count = DB::result(DB::query("SELECT COUNT(*) FROM ".DB::table('home_hall')), 0);
{
$query = DB::query("SELECT * FROM ".DB::table('home_hall')." limit $start, $perpage");
$data['isgold'] = 0;
echo "<td>{$v['uid']}</td>";
if($count){
DB::update('home_hall', array('isgold'=>$data['isgold']),array('id'=> $id));
$id = $_GET['id'] ? $_GET['id'] : 0;
$arr['filename'] = $filename;
}
if(!file_exists("data/video/{$uid}")){
$data['isindex'] = 0;
DB::delete('saige_gekufield', array('gid' => $gid));
$data['isgold'] = 1;
echo "<td><a href='admin.php?action=goldhall&id={$v['id']}&type=index&op=cancle'>取消首页推荐</a></td>";
$uid=empty($_POST['uid']) ? "" : $_POST['uid'];
$multipage = multi($count, $perpage, $page, $mpurl);
echo '<tr><td>用户id</td><td>展厅名</td><td>展厅级别</td><td>联系电话</td><td>操作</td><td>操作</td></tr>';
}
}
DB::delete('saige_gkcomment', array('gid' => $gid));
$data['isindex'] = 1;
}
//$query = DB::query($sql);
{
}
}
}
if($count1)
$details=empty($_POST['details']) ? "" : $_POST['details'];
mkdir("data/video/{$uid}", 0700);
echo "</tr>";
$arr['uid'] = $uid;
if($op == 'add'){
}elseif($type == 'index'){
echo "<td>{$v['telephone']}</td>";
echo "<tr>";
$count1=DB::insert('home_video',$arr);
更新
$arr['username'] = $username;
if(!file_exists("data/video/{$uid}/cover")){
$display_type=empty($_POST['display_type']) ? "" : $_POST['display_type'];
$query = DB::query("select * from ".DB::table('home_hall')." where id=$id");
echo "<td><a href='admin.php?action=goldhall&id={$v['id']}&type=index&op=add'>首页推荐</a></td>";
if($count)
DB::update('home_hall', array('isindex'=>$data['isindex']),array('id'=> $id));
else
}else{
echo("<script type='text/javascript'>alert('添加成功');window.location = \"admin.php?action=video\";</script>");
echo "<td><a href='admin.php?action=goldhall&id={$v['id']}&type=gold&op=add'>升级</a></td>";
}
if($multipage){
echo '</table>';
DB::delete('saige_geku', array('id' => $gid));
$arr['videoname'] = $videoname;
}
echo $v['isgold'] ? "<td>金牌</td>" : "<td>普通</td>";
foreach ($list as $k => $v){
$arr['details'] = $details;
}
if($v['isgold'] == 1){
while ($value = DB::fetch($query)) {
}
}
//$sql="insert into pre_home_video(uid,display_type,filename,default) values('$uid','$display_type','$filename','$default')";
{
if($_GET['op'] == 'delete'){
echo("<script type='text/javascript'>alert('添加失败,该用户不存在');</script>");
$filename=empty($_POST['filename']) ? "" : $_POST['filename'];
}
相关热词: discuz
本站内容来源于网络,如有侵权请与我们联系,我们会及时删除,我们深感抱歉!
注:本站所有信息仅供用于网络技术学习参考,学习中请遵循相关法律法规!
本文地址: https://v30.fanwenzhu.com/jz/discuz/4006.shtml
相关文章
热门TAG
win10 ecshop 主机 阿里云 解决 配置 C# C++ 解析 SQL语句 命令 Go语言 方法 CSS3 HTML5 CSS win7 MSSQL 服务器配置 IIS7.5 IIS7 IIS6 IIS CentOS 7 Linux oracle数据库 oracle phpcms discuz discuz教程最新文章
-
Discuz x2.5 伪静态规则成功
时间:2020-12-29
-
discuz X2正式版forum首页的
时间:2020-12-27
-
Discuz伪静态 配置搜索引擎
时间:2020-12-26
-
Discuz登录后总是显示未登
时间:2020-12-23
-
怎么换云服务器? Discuz论坛
时间:2020-12-23
-
Discuz!7.0主题回收站功能详
时间:2020-12-23
-
discuz 修改创始人密码、管
时间:2020-12-23
-
discuz论坛用户通过邮件验
时间:2020-12-23
热门文章
-
去掉discuz列表页的最新公告_Discuz模板开发
时间:2020-12-13
-
修改discuz X3.2论坛标题80个字符的长度限制
时间:2020-12-14
-
discuz 修改创始人密码、管理员登录密码的
时间:2020-12-23
-
discuz主题内容页面的打印按钮代码
时间:2020-12-13
-
Discuz!7.0主题回收站功能详解
时间:2020-12-23
-
footer.htm底部文件$_G['setting']['icp']、{if $
时间:2020-12-13
-
discuz教程_discuz视频教程_discuz论坛模板制
时间:2020-12-14
-
$article['related']Discuz 门户文章内容页的相
时间:2020-12-13
-
discuz教程_discuz视频教程_discuz论坛模板制
时间:2020-12-14
-
Discuz教程:使用微信登陆出现“目前无法
时间:2020-12-15
